Key to Income spreadsheet (Calculated in GB Pound)
Over the last 6 years I have made over 50 financial projections for different clients and companies.  I’ve never had a complaint. I like to exercise caution; it’s always best to under promise and over deliver. I expect we will have more users and the average yield to be higher but have adopted a cautious approach.
A. Month

B. Users (the amount of companies that are using the Sienna Software)

C to N This is the amount of revenue generated per user. The reason this figure spans 12 columns is to include potential. A new user will not suddenly reach full potential. I have factored increments of 20% every 2 months for companies to reach potential.

D4. (highlighted in pink) this is the average monthly return in GB Pound when a company has reached full potential. This figure is calculated by the 3 figures below in Purple.
C6= Reverence earned by residual Safari bookings made by Cape Villas 2009/2010 being R250,000 This is from a 20% commission rate. Sienna would take a 10% commission so the R250,000 is divided by two.
D6= Rand to Pound conversion
E6= R125,000 converted into GB Pounds then divided by 12 so it gives a monthly earning statistic.
I’ll just come back to that R250,000 figure and give a little more detail.
The basic concept evolved in the 09/10 summer season when I instructing staff to ask if clients they would like to book a Safari, 3 clients said yes and we made an additional R250,000 without and experience or marketing not even a website. I think given Sienna’s tools most companies will easily surpass Cape Villas figures but for the sake of under promising and over delivering that’s the figure I’ve chosen.

P. Total generated by Data link users. Data link partners are partners that we share data with, often by connecting directly into their databases via an API. These will our preferred and most profitable partners.

R. Total generated by Web Feed users. Web feed users connect our web pages to their website, but do not share content. Web feed users are still very important to us, some will grow to be more powerful than Data link users, but on average I estimate Web Feed users will he about half as productive as Data Link Users. This said setting up Web links is far easier than making a Data Link, so I estimate usage will double. So with twice as many users but half the income Data Link and Web Feed users will make similar returns.

T. Out the box. Out the box software is for companies that do not a website. Or don’t like their current website and wish to use Sienna to recreate their current site. After a while I expect these companies will do well but at first nowhere near as well as linked companies. It’s a difficult one to call but I’ve gone for only 5% as profitable as Data linked sites, this said with no set up cost and our word of mouth marketing we will see a lot more people giving it a go about tenfold I’d say. So with ten times that amount of users only making 5% of what Data Linked users make, I’s say Out the Box users will generate half of what Data linked users do.
This said, as the Game, TV Reality Show and the distribution with computers is complete I doubt it will take long for Out the Box software to be the main income source. This however has not been reflected in the spreadsheet.

V. Total by month. Monthly earnings combining the 3 income streams: Data linked, Web Feed & out the Box software. These are the earnings figures reflected on the “Expenses” Spread Sheet.

V64. 6 Year Earnings (In Pink) This is the total money generated by all user types in 6 years.